assignments

Entity Details

Name	assignments
Abbreviation
Primary Key	asn_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	asn_id	INTEGER(11)	Yes	No
No	title	VARCHAR(50)	Yes	No
No	course_id	INTEGER(11)	Yes	No		courses.course_id
No	file_name	VARCHAR(50)	No	No
No	description	VARCHAR(255)	No	No
No	rubric_id	INTEGER(11)	No	No		rubrics.rubric_id
No	due_date	DATETIME	No	No
No	release_date_begin	DATETIME	No	No
No	release_date_end	DATETIME	No	No

Relationship List (parent is assignments)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
assignments_group_assignments		assignments	group_assignments	Non Identifying	Zero or More	Yes
assignments_email		assignments	email	Non Identifying	Zero or More	Yes

Relationship List (child is assignments)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
courses_assignments		courses	assignments	Non Identifying	Zero or More	Yes
rubrics_assignments		rubrics	assignments	Non Identifying	Zero or More	No

courses

Entity Details

Name	courses
Abbreviation
Primary Key	course_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	course_id	INTEGER(11)	Yes	No
No	course	VARCHAR(50)	Yes	Yes
No	title	VARCHAR(50)	No	No
No	homepage	VARCHAR(100)	No	No
No	user_id	INTEGER(11)	No	No		users.user_id
No	status	ENUM('active','inactive')	Yes	No	'active'
No	self_enroll	BOOL	No	No
No	password	VARCHAR(25)	No	No

Relationship List (parent is courses)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
courses_enrols		courses	enrols	Identifying	Zero or More	Yes
courses_assignments		courses	assignments	Non Identifying	Zero or More	Yes
courses_groups		courses	groups	Non Identifying	Zero or More	Yes

Relationship List (child is courses)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_courses		users	courses	Non Identifying	Zero or More	No

email

Entity Details

Name	email
Abbreviation
Primary Key	email_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	email_id	INTEGER(11)	Yes	No
No	asn_id	INTEGER(11)	Yes	No		assignments.asn_id
No	subject	VARCHAR(255)	No	No
No	body	TEXT	No	No
No	date_created	DATETIME	No	No
No	date_last_mod	DATETIME	No	No

Relationship List (parent is email)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
email_email_groups		email	email_groups	Identifying	Zero or More	Yes
email_email_reminders		email	email_reminders	Non Identifying	Zero or More	Yes

Relationship List (child is email)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
assignments_email		assignments	email	Non Identifying	Zero or More	Yes

email_groups

Entity Details

Name	email_groups
Abbreviation
Primary Key	email_id, group_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	email_id	INTEGER(11)	Yes	No		email.email_id
Yes	group_id	INTEGER(11)	Yes	No		groups.group_id

Relationship List (child is email_groups)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
email_email_groups		email	email_groups	Identifying	Zero or More	Yes
groups_email_groups		groups	email_groups	Identifying	Zero or More	Yes

email_reminders

Entity Details

Name	email_reminders
Abbreviation
Primary Key	rem_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	rem_id	INTEGER(11)	Yes	No
No	email_id	INTEGER(11)	Yes	No		email.email_id
No	scheduled_date	DATETIME	Yes	No
No	job_number	INTEGER(11)	Yes	No	-1

Relationship List (child is email_reminders)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
email_email_reminders		email	email_reminders	Non Identifying	Zero or More	Yes

enrols

Entity Details

Name	enrols
Abbreviation
Primary Key	course_id, user_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	course_id	INTEGER(11)	Yes	No		courses.course_id
Yes	user_id	INTEGER(11)	Yes	No		users.user_id

Relationship List (child is enrols)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
courses_enrols		courses	enrols	Identifying	Zero or More	Yes
users_enrols		users	enrols	Identifying	Zero or More	Yes

evaluations

Entity Details

Name	evaluations
Abbreviation
Primary Key	id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	id	INTEGER(11)	Yes	No
No	evaluator_id	INTEGER(11)	Yes	No		evaluation_submissions.eval_id
No	evaluatee_id	INTEGER(11)	Yes	No		users.user_id
No	submitted	BOOL	Yes	No	'false'
No	general_comment	TEXT	No	No
No	total_grade	DOUBLE(12,2)	Yes	No	0

Relationship List (child is evaluations)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_evaluations		users	evaluations	Non Identifying	Zero or More	Yes
evaluation_submissions_evaluations		evaluation_submissions	evaluations	Non Identifying	Zero or More	Yes

evaluation_marks

Entity Details

Name	evaluation_marks
Abbreviation
Primary Key	id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	id	INTEGER(11)	Yes	No
No	evaluator_id	INTEGER(11)	Yes	No		evaluation_submissions.eval_id
No	evaluatee_id	INTEGER(11)	Yes	No		users.user_id
No	criteria_number	INTEGER(11)	Yes	No
No	criteria_comment	VARCHAR(255)	No	No
No	lom_number	INTEGER(11)	Yes	No	0
No	grade	DOUBLE(12,2)	No	No

Relationship List (child is evaluation_marks)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_evaluation_marks		users	evaluation_marks	Non Identifying	Zero or More	Yes
evaluation_submissions_evaluation_marks		evaluation_submissions	evaluation_marks	Non Identifying	Zero or More	Yes

evaluation_submissions

Entity Details

Name	evaluation_submissions
Abbreviation
Primary Key	eval_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	eval_id	INTEGER(11)	Yes	No
No	grp_asn_id	INTEGER(11)	Yes	No		group_assignments.grp_asn_id
No	user_id	INTEGER(11)	Yes	No		users.user_id
No	submitted	BOOL	Yes	No	'false'
No	date_submitted	DATETIME	No	No

Relationship List (parent is evaluation_submissions)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
evaluation_submissions_evaluations		evaluation_submissions	evaluations	Non Identifying	Zero or More	Yes
evaluation_submissions_evaluation_marks		evaluation_submissions	evaluation_marks	Non Identifying	Zero or More	Yes

Relationship List (child is evaluation_submissions)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_evaluation_submissions		users	evaluation_submissions	Non Identifying	Zero or More	Yes
group_assignments_evaluation_submissions		group_assignments	evaluation_submissions	Non Identifying	Zero or More	Yes

groups

Entity Details

Name	groups
Abbreviation
Primary Key	group_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	group_id	INTEGER(11)	Yes	No
No	group_number	INTEGER(11)	Yes	No
No	name	VARCHAR(50)	Yes	No
No	course_id	INTEGER(11)	Yes	No		courses.course_id

Relationship List (parent is groups)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
groups_group_members		groups	group_members	Identifying	Zero or More	Yes
groups_group_assignments		groups	group_assignments	Non Identifying	Zero or More	Yes
groups_email_groups		groups	email_groups	Identifying	Zero or More	Yes

Relationship List (child is groups)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
courses_groups		courses	groups	Non Identifying	Zero or More	Yes

group_assignments

Entity Details

Name	group_assignments
Abbreviation
Primary Key	grp_asn_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	grp_asn_id	INTEGER(11)	Yes	No
No	asn_id	INTEGER(11)	Yes	No		assignments.asn_id
No	group_id	INTEGER(11)	Yes	No		groups.group_id
No	marked	ENUM('not reviewed','reviewed')	Yes	No	'not reviewed'
No	grade	DOUBLE(12,2)	No	No

Relationship List (parent is group_assignments)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
group_assignments_evaluation_submissions		group_assignments	evaluation_submissions	Non Identifying	Zero or More	Yes

Relationship List (child is group_assignments)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
assignments_group_assignments		assignments	group_assignments	Non Identifying	Zero or More	Yes
groups_group_assignments		groups	group_assignments	Non Identifying	Zero or More	Yes

group_members

Entity Details

Name	group_members
Abbreviation
Primary Key	group_id, user_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	group_id	INTEGER(11)	Yes	No		groups.group_id
Yes	user_id	INTEGER(11)	Yes	No		users.user_id

Relationship List (child is group_members)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
groups_group_members		groups	group_members	Identifying	Zero or More	Yes
users_group_members		users	group_members	Identifying	Zero or More	Yes

rubrics

Entity Details

Name	rubrics
Abbreviation
Primary Key	rubric_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	rubric_id	INTEGER(11)	Yes	No
No	name	VARCHAR(20)	Yes	No
No	user_id	INTEGER(11)	Yes	No		users.user_id
No	total_mark	INTEGER(11)	No	No
No	zero_mark	BOOL	Yes	No	'false'
No	threshold_mark	DOUBLE(12,2)	No	No	-1
No	lom_max	INTEGER(11)	No	No
No	criteria	INTEGER(11)	No	No
No	availability	ENUM('public', 'private')	Yes	No	'public'
No	template	ENUM('horizontal', 'vertical')	Yes	No	'horizontal'
No	description	TEXT	No	No

Relationship List (parent is rubrics)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
rubrics_rubrics_lom		rubrics	rubrics_lom	Non Identifying	Zero or More	Yes
rubrics_rubrics_criteria		rubrics	rubrics_criteria	Non Identifying	Zero or More	Yes
rubrics_rubrics_criteria_comments		rubrics	rubrics_criteria_comments	Non Identifying	Zero or More	Yes
rubrics_assignments		rubrics	assignments	Non Identifying	Zero or More	No

Relationship List (child is rubrics)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_rubrics		users	rubrics	Non Identifying	Zero or More	Yes

rubrics_criteria

Entity Details

Name	rubrics_criteria
Abbreviation
Primary Key	id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	id	INTEGER(11)	Yes	No
No	rubric_id	INTEGER(11)	Yes	No		rubrics.rubric_id
No	criteria_number	INTEGER(11)	Yes	No
No	criteria	VARCHAR(255)	No	No
No	multiplier	INTEGER(11)	Yes	No

Relationship List (child is rubrics_criteria)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
rubrics_rubrics_criteria		rubrics	rubrics_criteria	Non Identifying	Zero or More	Yes

rubrics_criteria_comments

Entity Details

Name	rubrics_criteria_comments
Abbreviation
Primary Key	id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	id	INTEGER(11)	Yes	No
No	rubric_id	INTEGER(11)	Yes	No		rubrics.rubric_id
No	criteria_number	INTEGER(11)	Yes	No
No	lom_number	INTEGER(11)	Yes	No
No	criteria_comment	VARCHAR(255)	No	No

Relationship List (child is rubrics_criteria_comments)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
rubrics_rubrics_criteria_comments		rubrics	rubrics_criteria_comments	Non Identifying	Zero or More	Yes

rubrics_lom

Entity Details

Name	rubrics_lom
Abbreviation
Primary Key	id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	id	INTEGER(11)	Yes	No
No	rubric_id	INTEGER(11)	Yes	No		rubrics.rubric_id
No	lom_number	INTEGER(11)	Yes	No
No	lom_comment	VARCHAR(255)	No	No

Relationship List (child is rubrics_lom)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
rubrics_rubrics_lom		rubrics	rubrics_lom	Non Identifying	Zero or More	Yes

users

Entity Details

Name	users
Abbreviation
Primary Key	user_id
Primary Key Constraint Name
Description

Attribute List

PK	Attribute Name	Data Type	Required	Unique	Default	References
Yes	user_id	INTEGER(11)	Yes	No	'0'
No	username	VARCHAR(50)	Yes	Yes
No	password	VARCHAR(20)	Yes	No
No	first_name	VARCHAR(50)	No	No
No	last_name	VARCHAR(50)	No	No
No	user_type	ENUM('administrator','instructor','student')	Yes	No	'student'
No	status	ENUM('active','inactive')	Yes	No	'active'
No	lastlogin	DATETIME	No	No	'NULL'
No	email	VARCHAR(50)	No	No
No	student_number	VARCHAR(20)	No	No

Relationship List (parent is users)

Relationship Name	FK Constraint Name	Parent	Child	Type	Cardinality	Mandatory Parent
users_courses		users	courses	Non Identifying	Zero or More	No
users_enrols		users	enrols	Identifying	Zero or More	Yes
users_rubrics		users	rubrics	Non Identifying	Zero or More	Yes
users_group_members		users	group_members	Identifying	Zero or More	Yes
users_evaluation_submissions		users	evaluation_submissions	Non Identifying	Zero or More	Yes
users_evaluations		users	evaluations	Non Identifying	Zero or More	Yes
users_evaluation_marks		users	evaluation_marks	Non Identifying	Zero or More	Yes